Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text Only Default Behavior?
I was given an Excel spreadsheet from a small business client. It's very
simple - they track cash expenditures by day, so they have the dates listed in rows down the left side, and column headers with their expense categories across the top. The problem with the spreadsheet is that EVERY date you enter automatically converts to a serial number, and EVERY number converts to left justifed text. Even using a function results in the syntax of the function appearing as text in the cell, rather than the actual result of the function. Changing the formatting isn't working. I'm thinking there must be some setting or something that is allowing only text to be allowed in this spreadsheet. Does anyone else have any ideas? |
#2
|
|||
|
|||
Make sure that,
<Tools <Options <View tab, And "Formulas" is *NOT* checked. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- .. "Kirk P." wrote in message ... I was given an Excel spreadsheet from a small business client. It's very simple - they track cash expenditures by day, so they have the dates listed in rows down the left side, and column headers with their expense categories across the top. The problem with the spreadsheet is that EVERY date you enter automatically converts to a serial number, and EVERY number converts to left justifed text. Even using a function results in the syntax of the function appearing as text in the cell, rather than the actual result of the function. Changing the formatting isn't working. I'm thinking there must be some setting or something that is allowing only text to be allowed in this spreadsheet. Does anyone else have any ideas? |
#3
|
|||
|
|||
Perfect - thanks!
"Ragdyer" wrote: Make sure that, <Tools <Options <View tab, And "Formulas" is *NOT* checked. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- .. "Kirk P." wrote in message ... I was given an Excel spreadsheet from a small business client. It's very simple - they track cash expenditures by day, so they have the dates listed in rows down the left side, and column headers with their expense categories across the top. The problem with the spreadsheet is that EVERY date you enter automatically converts to a serial number, and EVERY number converts to left justifed text. Even using a function results in the syntax of the function appearing as text in the cell, rather than the actual result of the function. Changing the formatting isn't working. I'm thinking there must be some setting or something that is allowing only text to be allowed in this spreadsheet. Does anyone else have any ideas? |
#4
|
|||
|
|||
Appreciate the feed-back.
And, BTW, there is a keyboard shortcut to *toggle* between the "normal" and "formula" view: <Ctrl <` Which is a single open quotes, found in different places on different keyboards. Mine is under the <Esc key, above the <Tab key, to the left of the "1" and "!" key. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Kirk P." wrote in message ... Perfect - thanks! "Ragdyer" wrote: Make sure that, <Tools <Options <View tab, And "Formulas" is *NOT* checked. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - .. "Kirk P." wrote in message ... I was given an Excel spreadsheet from a small business client. It's very simple - they track cash expenditures by day, so they have the dates listed in rows down the left side, and column headers with their expense categories across the top. The problem with the spreadsheet is that EVERY date you enter automatically converts to a serial number, and EVERY number converts to left justifed text. Even using a function results in the syntax of the function appearing as text in the cell, rather than the actual result of the function. Changing the formatting isn't working. I'm thinking there must be some setting or something that is allowing only text to be allowed in this spreadsheet. Does anyone else have any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange behavior w/ Text, Button, & Check Boxes | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Adding default comment text | Excel Discussion (Misc queries) | |||
Set "print all text as black" as default in Excel | Excel Worksheet Functions | |||
how do i set default font / text size in comments? | Setting up and Configuration of Excel |