Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell format
Resolved · Low Priority · Version Standard
Kristina has attended:
Excel Introduction course
When using a dash in a number; eg 12-3, the cell will automatically change this to a date eg 12-march. Changing the cell format to general or number does not rectify this. Does this mean it is not possible to have a number such as 12-3 in a spreadsheet?
Hello
Before you type the number, set the format of the cell to be text. The dash is the problem here because as soon as you put this in excel will no longer recognise it as a number. you have to use text
regards
rich
|
Excel tip:Create your own custom list on Excel 2010!If you know how to use the auto-fill option on Excel then why not create your own customs lists? |
We'll call during UK business hours
Server loaded in 0.07 secs.