| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel replacing my text
I am trying to type in1/60 and excel keeps replacing it with Jan 60 how do I
stop this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel replacing my text
Either pre-format the cell as TEXT or precede the entry with an apostrophe
like this: '1/60. -- Biff Microsoft Excel MVP "Dutchess46514" wrote in message ... I am trying to type in1/60 and excel keeps replacing it with Jan 60 how do I stop this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel replacing my text
Hi Dutchess,
Try '1/60, if you want the division of 1/60, try "=1/60" (no quotes). Wkr JP "Dutchess46514" wrote in message ... I am trying to type in1/60 and excel keeps replacing it with Jan 60 how do I stop this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel replacing my text
Excel see 1/60 as a date.
Preformat the cell as text or preface 1/60 with an apostrophe which won't show in the cell. Gord Dibben MS Excel MVP On Sat, 12 Sep 2009 09:28:01 -0700, Dutchess46514 wrote: I am trying to type in1/60 and excel keeps replacing it with Jan 60 how do I stop this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - Fixed text code needs replacing with variable text | Excel Discussion (Misc queries) | |||
| Excel - replacing Text in workbooks | Excel Worksheet Functions | |||
| replacing text in all cells with existing text plus something | Excel Discussion (Misc queries) | |||
| Help replacing text with Yes or No | Excel Discussion (Misc queries) | |||
| Replacing text in Excel files on disk? | Excel Discussion (Misc queries) | |||
Linear Mode
