ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Test question (https://www.excelbanter.com/excel-discussion-misc-queries/126444-test-question.html)

colmkav

Test question
 
To avoid entering a fraction as a date (Excell 2000) what can be added
before the fraction to tell it is a fraction (one of F, //, 0, FR)?


RagDyeR

Test question
 
Zero <Space 1/2
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"colmkav" wrote in message
oups.com...
To avoid entering a fraction as a date (Excell 2000) what can be added
before the fraction to tell it is a fraction (one of F, //, 0, FR)?



ufo_pilot

Test question
 
You can also :
select entire sheet
FormatCellsNumber(tab) Text




"RagDyeR" wrote:

Zero <Space 1/2
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"colmkav" wrote in message
oups.com...
To avoid entering a fraction as a date (Excell 2000) what can be added
before the fraction to tell it is a fraction (one of F, //, 0, FR)?




colmkav

Test question
 
thx
ufo_pilot wrote:
You can also :
select entire sheet
FormatCellsNumber(tab) Text




"RagDyeR" wrote:

Zero <Space 1/2
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"colmkav" wrote in message
oups.com...
To avoid entering a fraction as a date (Excell 2000) what can be added
before the fraction to tell it is a fraction (one of F, //, 0, FR)?






All times are GMT +1. The time now is 05:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com