| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Sorry I meant use '# ?/?' without the quotes and enter numbers as 0 1/2 for
example -- HTH RP (remove nothere from the email address if mailing direct) "Bob Phillips" wrote in message news:... If you are inputting fractions, format the cells as ' ?/?@ without the quotes. -- HTH RP (remove nothere from the email address if mailing direct) "Hugh" not.com" wrote in message ... Go to FormatCellNumberwhat ever format you want. Sounds like your cells are formatted as dates. RachaelDPT wrote: I am trying to set up an excel spreadsheet and it is automatically changing all my numbers into dates. Ahhh I just want my data values, no formuals needed. Help please, I'm getting frustrated!!!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel countif based on size of numbers in one column in Access | Excel Worksheet Functions | |||
| Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
| How do I stop Excel from changing numbers into a date? | Excel Discussion (Misc queries) | |||
| I have a set of numbers in an excel spreadsheet and want to find t | Excel Discussion (Misc queries) | |||
| how do i set up to auto detect duplicated numbers in an excel fiel | Excel Discussion (Misc queries) | |||
Threaded Mode
